There are a few ways to remove common values in Excel under different rows.

Using the Remove Duplicates feature:

1. Select the range of cells that you want to remove the common values from.
2. Click on the Data tab.
3. In the Data Tools group, click on the Remove Duplicates button.
4. In the Remove Duplicates dialog box, select the columns that you want to remove the duplicates from.
5. Click on the OK button.

Using the Advanced Filter feature:

1. Select the range of cells that you want to remove the common values from.
2. Click on the Data tab.
3. In the Sort & Filter group, click on the Advanced button.
4. In the Advanced Filter dialog box, select the Remove Duplicates option.
5. Select the columns that you want to remove the duplicates from.
6. Click on the OK button.

Using a VBA macro:

You can also use a VBA macro to remove common values in Excel under different rows. The following is a VBA macro that you can use:

VBA

Sub RemoveCommonValues()

' This macro removes common values in Excel under different rows.

Dim rng As Range
Dim i As Long
Dim j As Long

' Set the range of cells that you want to remove the common values from.
Set rng = Range("A1:B10")

' For each row in the range,
For i = 1 To rng.Rows.Count

    ' For each cell in the row,
    For j = 1 To rng.Columns.Count

        ' If the value of the cell is already in the current row,
        If rng(i, j).Value In rng(i, 1:j - 1) Then

            ' Remove the value from the cell.
            rng(i, j).Value = ""

        End If

    Next j

Next i

End Sub

To use this macro, copy and paste it into a VBA module and then run the macro.